java UnitilsException: Executed scripts table "PUBLIC"."DBMAINTAIN_SCRIPTS" doesn't exist yet or is invalid [closed]
Posted
by
Philippe
on Programmers
See other posts from Programmers
or by Philippe
Published on 2012-08-27T04:40:16Z
Indexed on
2012/08/29
3:50 UTC
Read the original article
Hit count: 399
java
I want use Unitils for testing my JAVA program, i have following error message "UnitilsException: Executed scripts table "PUBLIC"."DBMAINTAIN_SCRIPTS" doesn't exist yet or is invalid"
My table is into an DDL file, and table is not created
Could you says me if dataSetStructureGenerator.xsd.dirName=src/test/resources/dataset-schema properties is still active in unitils 3.3 ?
My EMPLOYEE table is not created and DBMAINTAIN_SCRIPTS not created too Where is my mistake ?
My DDL file
SET REFERENTIAL_INTEGRITY FALSE;
SET DATABASE COLLATION "French";
SET SCHEMA PUBLIC;
CREATE TABLE DBMAINTAIN_SCRIPTS (FILE_NAME VARCHAR2(150), FILE_LAST_MODIFIED_AT INTEGER, CHECKSUM VARCHAR2(50), EXECUTED_AT VARCHAR2(20), SUCCEEDED INTEGER);
CREATE TABLE EMPLOYEES(ID IDENTITY NOT NULL,NAME VARCHAR(20),TITLE VARCHAR(20),SALARY DOUBLE,NI INTEGER NOT NULL)
My unitils properties file
# comments documenting these unitils configuration properties removed for
# brevity. look for commenting in unitils-default.properties in the root of the
# unitils jar if needed.
unitils.modules=database,dbunit,easymock,inject
unitils.module.hibernate.enabled=false
unitils.module.spring.enabled=false
# these placeholders are set in avaje.properties
#gere la configuration DBUNIT
database.driverClassName=org.hsqldb.jdbcDriver
database.url=jdbc:hsqldb:mem:unitils-example
database.schemaNames=PUBLIC
database.userName=SA
database.password=
database.dialect=hsqldb
# unitils will construct the test database using the ddl file found in this
# directory
dbMaintainer.fileScriptSource.scripts.location=src/main/resources
updateDataBaseSchema.enabled=true
sequenceUpdater.sequencevalue.lowestacceptable=100
dataSetStructureGenerator.xsd.dirName=src/test/resources/dataset-schema
#dbMaintainer.autoCreateExecutedScriptsTable property to true
© Programmers or respective owner